﻿CREATE TABLE [dbo].[DepDesignationMapping]
(
	[ID]                INT   IDENTITY (1, 1) NOT NULL,
	[DepartmentID]     INT      NOT NULL,
	[DesignationID]		INT      NOT NULL
)

GO

ALTER TABLE [dbo].[DepDesignationMapping]
	ADD CONSTRAINT [PK_DepDesignationMapping]
	PRIMARY KEY ([ID])
